1. Processing the Final energy comsumption data
[('nrg_bal_s',), ('nrg_inf_epcrw',)]
The first dataset: "Simplified energy balances" dates from 1990 to 2020.
The second dataset: "Electricity production capacities for renewables and wastes" dates from 1990 to 2020.

Final consumption - energy use (Gigawatt-hour)

nrg_bal siec unit geo date value
5778 Final consumption - energy use Total Gigawatt-hour Albania 2020 21474.051
5779 Final consumption - energy use Total Gigawatt-hour Austria 2020 288624.871
5780 Final consumption - energy use Total Gigawatt-hour Bosnia and Herzegovina 2020 46804.808
5781 Final consumption - energy use Total Gigawatt-hour Belgium 2020 360985.528
5782 Final consumption - energy use Total Gigawatt-hour Bulgaria 2020 110633.154
siec plant_tec unit geo date value
0 Solid biofuels Net maximum electrical capacity Megawatt Albania 2020 0.000
1 Solid biofuels Net maximum electrical capacity Megawatt Austria 2020 816.199
2 Solid biofuels Net maximum electrical capacity Megawatt Bosnia and Herzegovina 2020 1.120
3 Solid biofuels Net maximum electrical capacity Megawatt Belgium 2020 563.500
4 Solid biofuels Net maximum electrical capacity Megawatt Bulgaria 2020 15.064
('Electricity production capacities for renewables and wastes', '1990', '2020')
5086.291
nrg_bal siec unit geo date value value_population per_capita
22 Final consumption - energy use Total Gigawatt-hour Latvia 2020 44172.893 1907675 23.155356
Index(['nrg_bal', 'siec', 'unit', 'geo', 'date', 'value'], dtype='object')
array(['Available for final consumption', 'Distribution losses',
       'Exports', 'Final consumption - energy use',
       'Final consumption - industry sector - construction - energy use',
       'Final consumption - industry sector - chemical and petrochemical - energy use',
       'Final consumption - industry sector - energy use',
       'Final consumption - industry sector - food, beverages and tobacco - energy use',
       'Final consumption - industry sector - iron and steel - energy use',
       'Final consumption - industry sector - machinery - energy use',
       'Final consumption - industry sector - mining and quarrying - energy use',
       'Final consumption - industry sector - non-ferrous metals - energy use',
       'Final consumption - industry sector - non-metallic minerals - energy use',
       'Final consumption - industry sector - not elsewhere specified - energy use',
       'Final consumption - industry sector - paper, pulp and printing - energy use',
       'Final consumption - industry sector - transport equipment - energy use',
       'Final consumption - industry sector - textile and leather - energy use',
       'Final consumption - industry sector - wood and wood products - energy use',
       'Final consumption - non-energy use',
       'Final consumption - other sectors - agriculture and forestry - energy use',
       'Final consumption - other sectors - commercial and public services - energy use',
       'Final consumption - other sectors - energy use',
       'Final consumption - other sectors - fishing - energy use',
       'Final consumption - other sectors - households - energy use',
       'Final consumption - other sectors - not elsewhere specified - energy use',
       'Final consumption - transport sector - domestic aviation - energy use',
       'Final consumption - transport sector - domestic navigation - energy use',
       'Final consumption - transport sector - energy use',
       'Final consumption - transport sector - not elsewhere specified - energy use',
       'Final consumption - transport sector - pipeline transport - energy use',
       'Final consumption - transport sector - rail - energy use',
       'Final consumption - transport sector - road - energy use',
       'Final energy consumption (Europe 2020-2030)',
       'Gross available energy', 'Gross electricity production',
       'Gross heat production', 'Gross inland consumption',
       'Gross inland consumption (Europe 2020-2030)', 'Imports',
       'International aviation', 'International maritime bunkers',
       'Total energy supply',
       'Energy sector - blast furnaces - energy use',
       'Energy sector - gasification plants for biogas - energy use',
       'Energy sector - brown coal briquettes and peat briquettes plants - energy use',
       'Energy sector - coal liquefaction plants - energy use',
       'Energy sector - coal mines - energy use',
       'Energy sector - coke ovens - energy use',
       'Energy sector - charcoal production plants - energy use',
       'Energy sector - energy use',
       'Energy sector - electricity and heat generation - energy use',
       'Energy sector - gas-to-liquids plants - energy use',
       'Energy sector - gas works - energy use',
       'Energy sector - liquefaction and regasification plants (LNG) - energy use',
       'Energy sector - nuclear industry - energy use',
       'Energy sector - not elsewhere specified - energy use',
       'Energy sector - oil and natural gas extraction plants - energy use',
       'Energy sector - patent fuel plants - energy use',
       'Energy sector - petroleum refineries (oil refineries) - energy use',
       'Primary energy consumption (Europe 2020-2030)',
       'Primary production', 'Recovered and recycled products',
       'Statistical differences', 'Change in stock',
       'Transformation input - blast furnaces - energy use',
       'Transformation input - brown coal briquettes and peat briquettes plants - energy use',
       'Transformation input - for blended natural gas - energy use',
       'Transformation input - coal liquefaction plants - energy use',
       'Transformation input - coke ovens - energy use',
       'Transformation input - charcoal production plants - energy use',
       'Transformation input - energy use',
       'Transformation input - electricity and heat generation - energy use',
       'Transformation input - gas-to-liquids plants - energy use',
       'Transformation input - gas works - energy use',
       'Transformation input - liquid biofuels blended - energy use',
       'Transformation input - not elsewhere specified - energy use',
       'Transformation input - patent fuel plants - energy use',
       'Transformation input - refineries and petrochemical industry - energy use',
       'Transformation output', 'Transformation output - blast furnaces',
       'Transformation output - brown coal briquettes and peat briquettes plants',
       'Transformation output - blended in natural gas',
       'Transformation output - coal liquefaction plants',
       'Transformation output - coke ovens',
       'Transformation output - charcoal production plants',
       'Transformation output - electricity and heat generation',
       'Transformation output - gas-to-liquids plants',
       'Transformation output - gas works',
       'Transformation output - liquid biofuels blended',
       'Transformation output - not elsewhere specified',
       'Transformation output - patent fuel plants',
       'Transformation output - refineries and petrochemical industry'],
      dtype=object)
siec plant_tec unit geo date value
25 Solid biofuels Net maximum electrical capacity Megawatt Latvia 2020 96.067
197 Biogases Net maximum electrical capacity Megawatt Latvia 2020 60.246
240 Hydro Net maximum electrical capacity Megawatt Latvia 2020 1586.276
455 Geothermal Net maximum electrical capacity Megawatt Latvia 2020 0.000
498 Wind Net maximum electrical capacity Megawatt Latvia 2020 77.922
627 Solar Net maximum electrical capacity Megawatt Latvia 2020 5.102
nrg_bal siec unit geo date value
52254 Gross electricity production Total Gigawatt-hour Latvia 2020 5724.846
nrg_bal siec unit geo date value
51006 Gross electricity production Solid fossil fuels Gigawatt-hour Latvia 2020 0.0
51132 Gross electricity production Manufactured gases Gigawatt-hour Latvia 2020 0.0
51256 Gross electricity production Electricity Gigawatt-hour Latvia 2020 None
51378 Gross electricity production Natural gas Gigawatt-hour Latvia 2020 2075.163
51502 Gross electricity production Heat Gigawatt-hour Latvia 2020 None
51624 Gross electricity production Nuclear heat Gigawatt-hour Latvia 2020 0.0
51750 Gross electricity production Oil and petroleum products (excluding biofuel ... Gigawatt-hour Latvia 2020 0.106
51876 Gross electricity production Peat and peat products Gigawatt-hour Latvia 2020 0.048
52002 Gross electricity production Renewables and biofuels Gigawatt-hour Latvia 2020 3649.529
52128 Gross electricity production Oil shale and oil sands Gigawatt-hour Latvia 2020 0.0
52254 Gross electricity production Total Gigawatt-hour Latvia 2020 5724.846
52380 Gross electricity production Non-renewable waste Gigawatt-hour Latvia 2020 0.0
---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
Cell In [34], line 1
----> 1 df_get_renew.shape

NameError: name 'df_get_renew' is not defined
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 1224180 entries, 0 to 1224179
Data columns (total 35 columns):
 #   Column   Non-Null Count    Dtype  
---  ------   --------------    -----  
 0   nrg_bal  1224180 non-null  object 
 1   siec     1224180 non-null  object 
 2   unit     1224180 non-null  object 
 3   geo      1224180 non-null  object 
 4   2020     653130 non-null   float64
 5   2019     669060 non-null   float64
 6   2018     669060 non-null   float64
 7   2017     669060 non-null   float64
 8   2016     669060 non-null   float64
 9   2015     669060 non-null   float64
 10  2014     669060 non-null   float64
 11  2013     653130 non-null   float64
 12  2012     637200 non-null   float64
 13  2011     637200 non-null   float64
 14  2010     637200 non-null   float64
 15  2009     621270 non-null   float64
 16  2008     621270 non-null   float64
 17  2007     621270 non-null   float64
 18  2006     621270 non-null   float64
 19  2005     621270 non-null   float64
 20  2004     605340 non-null   float64
 21  2003     605340 non-null   float64
 22  2002     605340 non-null   float64
 23  2001     605340 non-null   float64
 24  2000     605340 non-null   float64
 25  1999     589410 non-null   float64
 26  1998     589410 non-null   float64
 27  1997     589410 non-null   float64
 28  1996     589410 non-null   float64
 29  1995     589410 non-null   float64
 30  1994     589410 non-null   float64
 31  1993     589410 non-null   float64
 32  1992     589410 non-null   float64
 33  1991     589410 non-null   float64
 34  1990     1075140 non-null  object 
dtypes: float64(30), object(5)
memory usage: 326.9+ MB

All the further steps are taken to get final energy consumption for all countries from 2012 to 2020 in GWh measurement unit

['Available for final consumption' 'Distribution losses' 'Exports'
 'Final consumption - energy use'
 'Final consumption - industry sector - construction - energy use'
 'Final consumption - industry sector - chemical and petrochemical - energy use'
 'Final consumption - industry sector - energy use'
 'Final consumption - industry sector - food, beverages and tobacco - energy use'
 'Final consumption - industry sector - iron and steel - energy use'
 'Final consumption - industry sector - machinery - energy use'
 'Final consumption - industry sector - mining and quarrying - energy use'
 'Final consumption - industry sector - non-energy use'
 'Final consumption - industry sector - non-ferrous metals - energy use'
 'Final consumption - industry sector - non-metallic minerals - energy use'
 'Final consumption - industry sector - not elsewhere specified - energy use'
 'Final consumption - industry sector - paper, pulp and printing - energy use'
 'Final consumption - industry sector - transport equipment - energy use'
 'Final consumption - industry sector - textile and leather - energy use'
 'Final consumption - industry sector - wood and wood products - energy use'
 'Final consumption - non-energy use'
 'Final consumption - other sectors - agriculture and forestry - energy use'
 'Final consumption - other sectors - commercial and public services - energy use'
 'Final consumption - other sectors - energy use'
 'Final consumption - other sectors - fishing - energy use'
 'Final consumption - other sectors - households - energy use'
 'Final consumption - other sectors - non-energy use'
 'Final consumption - other sectors - not elsewhere specified - energy use'
 'Final consumption - transport sector - domestic aviation - energy use'
 'Final consumption - transport sector - domestic navigation - energy use'
 'Final consumption - transport sector - energy use'
 'Final consumption - transport sector - non-energy use'
 'Final consumption - transport sector - not elsewhere specified - energy use'
 'Final consumption - transport sector - pipeline transport - energy use'
 'Final consumption - transport sector - rail - energy use'
 'Final consumption - transport sector - road - energy use'
 'Final energy consumption (Europe 2020-2030)' 'Gross available energy'
 'Gross electricity production'
 'Gross electricity production - autoproducer combined heat and power'
 'Gross electricity production - autoproducer electricity only'
 'Gross electricity production - main activity producer combined heat and power'
 'Gross electricity production - main activity producer electricity only'
 'Gross heat production'
 'Gross heat production - autoproducer combined heat and power'
 'Gross heat production - autoproducer heat only'
 'Gross heat production - main activity producer combined heat and power'
 'Gross heat production - main activity producer heat only'
 'Gross inland consumption' 'Gross inland consumption (Europe 2020-2030)'
 'Imports' 'International aviation' 'International maritime bunkers'
 'Total energy supply' 'Energy sector - blast furnaces - energy use'
 'Energy sector - gasification plants for biogas - energy use'
 'Energy sector - brown coal briquettes and peat briquettes plants - energy use'
 'Energy sector - coal liquefaction plants - energy use'
 'Energy sector - coal mines - energy use'
 'Energy sector - coke ovens - energy use'
 'Energy sector - charcoal production plants - energy use'
 'Energy sector - energy use'
 'Energy sector - electricity and heat generation - energy use'
 'Energy sector - gas-to-liquids plants - energy use'
 'Energy sector - gas works - energy use'
 'Energy sector - liquefaction and regasification plants (LNG) - energy use'
 'Energy sector - non-energy use'
 'Energy sector - nuclear industry - energy use'
 'Energy sector - not elsewhere specified - energy use'
 'Energy sector - oil and natural gas extraction plants - energy use'
 'Energy sector - patent fuel plants - energy use'
 'Energy sector - petroleum refineries (oil refineries) - energy use'
 'Primary energy consumption (Europe 2020-2030)' 'Primary production'
 'Recovered and recycled products' 'Statistical differences'
 'Change in stock' 'Transformation input - blast furnaces - energy use'
 'Transformation input - brown coal briquettes and peat briquettes plants - energy use'
 'Transformation input - for blended natural gas - energy use'
 'Transformation input - coal liquefaction plants - energy use'
 'Transformation input - coke ovens - energy use'
 'Transformation input - charcoal production plants - energy use'
 'Transformation input - energy use'
 'Transformation input - electricity and heat generation - autoproducer combined heat and power - energy use'
 'Transformation input - electricity and heat generation - autoproducer electricity only - energy use'
 'Transformation input - electricity and heat generation - autoproducer heat only - energy use'
 'Transformation input - electricity and heat generation - derived heat for electricity production'
 'Transformation input - electricity and heat generation - energy use'
 'Transformation input - electricity and heat generation - electric boilers'
 'Transformation input - electricity and heat generation - electrically driven heat pumps'
 'Transformation input - electricity and heat generation - electricity for pumped storage'
 'Transformation input - electricity and heat generation - main activity producer combined heat and power - energy use'
 'Transformation input - electricity and heat generation - main activity producer electricity only - energy use'
 'Transformation input - electricity and heat generation - main activity producer heat only - energy use'
 'Transformation input - gas-to-liquids plants - energy use'
 'Transformation input - gas works - energy use'
 'Transformation input - liquid biofuels blended - energy use'
 'Transformation input - non-energy use'
 'Transformation input, energy sector and final consumption in industry sector - non-energy use'
 'Transformation input - not elsewhere specified - energy use'
 'Transformation input - patent fuel plants - energy use'
 'Transformation input - refineries and petrochemical industry - backflows from petrochemical industry - energy use'
 'Transformation input - refineries and petrochemical industry - direct use - energy use'
 'Transformation input - refineries and petrochemical industry - energy use'
 'Transformation input - refineries and petrochemical industry - interproduct transfers - energy use'
 'Transformation input - refineries and petrochemical industry - petrochemical industry intake - energy use'
 'Transformation input - refineries and petrochemical industry - products transferred - energy use'
 'Transformation input - refineries and petrochemical industry - refinery intake - energy use'
 'Transformation output' 'Transformation output - blast furnaces'
 'Transformation output - brown coal briquettes and peat briquettes plants'
 'Transformation output - blended in natural gas'
 'Transformation output - coal liquefaction plants'
 'Transformation output - coke ovens'
 'Transformation output - charcoal production plants'
 'Transformation output - electricity and heat generation'
 'Transformation output - electricity and heat generation - autoproducer combined heat and power'
 'Transformation output - electricity and heat generation - autoproducer electricity only'
 'Transformation output - electricity and heat generation - autoproducer heat only'
 'Transformation output - electricity and heat generation - electric boilers'
 'Transformation output - electricity and heat generation - electrically driven heat pumps'
 'Transformation output - electricity and heat generation - main activity producer combined heat and power'
 'Transformation output - electricity and heat generation - main activity producer electricity only'
 'Transformation output - electricity and heat generation - main activity producer heat only'
 'Transformation output - electricity and heat generation - other sources'
 'Transformation output - electricity and heat generation - pumped hydro'
 'Transformation output - gas-to-liquids plants'
 'Transformation output - gas works'
 'Transformation output - liquid biofuels blended'
 'Transformation output - not elsewhere specified'
 'Transformation output - patent fuel plants'
 'Transformation output - refineries and petrochemical industry'
 'Transformation output - refineries and petrochemical industry - backflows'
 'Transformation output - refineries and petrochemical industry - interproduct transfers'
 'Transformation output - refineries and petrochemical industry - petrochemical industry returns'
 'Transformation output - refineries and petrochemical industry - primary product receipts'
 'Transformation output - refineries and petrochemical industry - products transferred'
 'Transformation output - refineries and petrochemical industry - refinery output']
nrg_bal siec unit geo 2020 2019 2018 2017 2016 2015 ... 1998 1997 1996 1995 1994 1993 1992 1991 1990 nrg_bal_obj
0 Available for final consumption Bioenergy Gigawatt-hour Albania 3013.181 3211.056 3129.617 2804.720 3049.733 2728.383 ... 3192.500 3344.722 3504.167 3671.389 3846.389 4029.722 4221.944 4221.944 4221.944 Available for final consumption
1 Available for final consumption Bioenergy Gigawatt-hour Austria 54591.852 55571.298 55689.684 58228.039 57876.168 57507.590 ... 27778.728 28863.769 29117.247 27703.651 25186.310 27367.890 27110.141 27905.111 25744.633 Available for final consumption
2 Available for final consumption Bioenergy Gigawatt-hour Bosnia and Herzegovina 14750.870 13990.576 13379.486 4843.579 5936.294 5937.175 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN Available for final consumption
3 Available for final consumption Bioenergy Gigawatt-hour Belgium 27827.872 25799.034 27791.685 27165.203 26994.596 25412.611 ... 4792.250 4198.739 4464.628 4344.736 3076.269 3139.375 3958.904 4108.185 4034.103 Available for final consumption
4 Available for final consumption Bioenergy Gigawatt-hour Bulgaria 18159.810 16781.094 16364.406 14661.761 14428.844 13753.572 ... 4759.722 2776.667 2724.166 2394.221 1865.723 1656.454 1818.057 1333.333 2005.833 Available for final consumption

5 rows × 36 columns

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 1224180 entries, 0 to 1224179
Data columns (total 36 columns):
 #   Column       Non-Null Count    Dtype  
---  ------       --------------    -----  
 0   nrg_bal      1224180 non-null  object 
 1   siec         1224180 non-null  object 
 2   unit         1224180 non-null  object 
 3   geo          1224180 non-null  object 
 4   2020         653130 non-null   float64
 5   2019         669060 non-null   float64
 6   2018         669060 non-null   float64
 7   2017         669060 non-null   float64
 8   2016         669060 non-null   float64
 9   2015         669060 non-null   float64
 10  2014         669060 non-null   float64
 11  2013         653130 non-null   float64
 12  2012         637200 non-null   float64
 13  2011         637200 non-null   float64
 14  2010         637200 non-null   float64
 15  2009         621270 non-null   float64
 16  2008         621270 non-null   float64
 17  2007         621270 non-null   float64
 18  2006         621270 non-null   float64
 19  2005         621270 non-null   float64
 20  2004         605340 non-null   float64
 21  2003         605340 non-null   float64
 22  2002         605340 non-null   float64
 23  2001         605340 non-null   float64
 24  2000         605340 non-null   float64
 25  1999         589410 non-null   float64
 26  1998         589410 non-null   float64
 27  1997         589410 non-null   float64
 28  1996         589410 non-null   float64
 29  1995         589410 non-null   float64
 30  1994         589410 non-null   float64
 31  1993         589410 non-null   float64
 32  1992         589410 non-null   float64
 33  1991         589410 non-null   float64
 34  1990         1075140 non-null  object 
 35  nrg_bal_obj  1224180 non-null  object 
dtypes: float64(30), object(6)
memory usage: 336.2+ MB
nrg_bal siec unit geo 2020 2019 2018 2017 2016 2015 ... 1998 1997 1996 1995 1994 1993 1992 1991 1990 nrg_bal_obj
27120 Final consumption - energy use Bioenergy Gigawatt-hour Albania 3080.264 3211.056 3129.617 2804.720 3049.733 2728.383 ... 3192.500 3344.722 3504.167 3671.389 3846.389 4029.722 4221.944 4221.944 4221.944 Final consumption - energy use
27121 Final consumption - energy use Bioenergy Gigawatt-hour Austria 54617.316 55603.307 55714.824 58250.872 57903.829 57534.736 ... 27778.698 28863.741 29117.257 27703.637 25186.305 27367.955 27110.124 27905.100 25744.602 Final consumption - energy use
27122 Final consumption - energy use Bioenergy Gigawatt-hour Bosnia and Herzegovina 14750.870 13990.576 13379.208 4843.852 5936.572 5919.490 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN Final consumption - energy use
27123 Final consumption - energy use Bioenergy Gigawatt-hour Belgium 28321.853 26215.905 28111.988 27509.906 27338.839 25723.481 ... 4792.250 4198.739 4464.628 4344.736 3076.269 3139.375 3958.904 4108.185 4034.103 Final consumption - energy use
27124 Final consumption - energy use Bioenergy Gigawatt-hour Bulgaria 18258.865 17015.287 16340.454 14731.810 14439.100 13761.236 ... 4751.944 2723.611 2490.833 2277.554 1795.168 1560.620 1746.946 1333.333 2005.833 Final consumption - energy use
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
36139 Final consumption - energy use Non-renewable municipal waste Terajoule Slovakia 515.000 440.000 8.000 419.000 71.000 550.000 ... 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 Final consumption - energy use
36140 Final consumption - energy use Non-renewable municipal waste Terajoule Türkiye 0.000 0.000 0.000 0.000 0.000 0.000 ... 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 Final consumption - energy use
36141 Final consumption - energy use Non-renewable municipal waste Terajoule Ukraine 0.000 0.000 0.000 0.000 0.000 0.000 ... 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 Final consumption - energy use
36142 Final consumption - energy use Non-renewable municipal waste Terajoule United Kingdom NaN 5475.000 5504.000 5275.000 4193.000 4709.000 ... 286.000 186.000 673.000 656.000 605.000 525.000 531.000 571.000 536.000 Final consumption - energy use
36143 Final consumption - energy use Non-renewable municipal waste Terajoule Kosovo (under United Nations Security Council ... 0.000 0.000 0.000 0.000 0.000 0.000 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN Final consumption - energy use

9024 rows × 36 columns

['Bioenergy' 'Solid fossil fuels' 'Anthracite' 'Coking coal'
 'Other bituminous coal' 'Sub-bituminous coal' 'Lignite' 'Coke oven coke'
 'Gas coke' 'Patent fuel' 'Brown coal briquettes' 'Coal tar'
 'Coke oven gas' 'Manufactured gases' 'Gas works gas' 'Blast furnace gas'
 'Other recovered gases' 'Electricity' 'Fossil energy' 'Natural gas'
 'Heat' 'Nuclear heat'
 'Oil and petroleum products (excluding biofuel portion)' 'Crude oil'
 'Natural gas liquids' 'Refinery feedstocks'
 'Additives and oxygenates (excluding biofuel portion)'
 'Other hydrocarbons' 'Refinery gas' 'Ethane' 'Liquefied petroleum gases'
 'Naphtha' 'Aviation gasoline'
 'Motor gasoline (excluding biofuel portion)' 'Gasoline-type jet fuel'
 'Kerosene-type jet fuel (excluding biofuel portion)' 'Other kerosene'
 'Gas oil and diesel oil (excluding biofuel portion)' 'Fuel oil'
 'White spirit and special boiling point industrial spirits' 'Lubricants'
 'Paraffin waxes' 'Petroleum coke' 'Bitumen' 'Other oil products n.e.c.'
 'Peat and peat products' 'Peat' 'Peat products' 'Primary solid biofuels'
 'Charcoal' 'Blended biogasoline' 'Pure biogasoline' 'Blended biodiesels'
 'Pure biodiesels' 'Blended bio jet kerosene' 'Pure bio jet kerosene'
 'Other liquid biofuels' 'Biogases' 'Renewables and biofuels' 'Hydro'
 'Geothermal' 'Wind' 'Solar thermal' 'Solar photovoltaic'
 'Tide, wave, ocean' 'Ambient heat (heat pumps)' 'Oil shale and oil sands'
 'Total' 'Industrial waste (non-renewable)' 'Non-renewable waste'
 'Renewable municipal waste' 'Non-renewable municipal waste']
nrg_bal siec unit geo 2020 2019 2018 2017 2016 2015 ... 1998 1997 1996 1995 1994 1993 1992 1991 1990 nrg_bal_obj
35514 Final consumption - energy use Total Gigawatt-hour Albania 21474.051 23876.813 24820.884 24177.936 22091.860 22823.850 ... 10719.609 9611.654 11928.655 11037.049 10912.369 10922.459 11889.507 16371.327 22265.844 Final consumption - energy use
35515 Final consumption - energy use Total Gigawatt-hour Austria 288624.871 305027.230 302830.312 308232.060 303542.303 296290.399 ... 250415.878 243008.558 248958.967 229092.039 218885.178 224114.636 220061.112 225737.683 208914.111 Final consumption - energy use
35516 Final consumption - energy use Total Gigawatt-hour Bosnia and Herzegovina 46804.808 48935.410 48984.752 40680.956 41215.947 38575.626 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN Final consumption - energy use
35517 Final consumption - energy use Total Gigawatt-hour Belgium 360985.528 378903.241 385929.337 383395.441 388756.658 385533.434 ... 387543.245 379346.273 387137.413 363532.757 353682.831 347129.988 350916.864 348200.881 330464.804 Final consumption - energy use
35518 Final consumption - energy use Total Gigawatt-hour Bulgaria 110633.154 112889.753 113452.073 113344.852 110693.751 109188.868 ... 115074.279 118430.761 128131.965 124760.205 118611.468 118097.784 121937.584 138556.553 185601.676 Final consumption - energy use
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
35635 Final consumption - energy use Total Terajoule Slovakia 402389.827 429080.035 414975.319 414619.929 386263.255 374286.417 ... 424205.646 431833.322 431327.049 416147.139 413354.335 427741.246 467297.483 494195.555 579625.615 Final consumption - energy use
35636 Final consumption - energy use Total Terajoule Türkiye 4234655.450 4149124.802 4129566.302 4206687.475 3781439.427 3636109.261 ... 2057017.821 2075910.541 2013489.806 1849464.822 1681540.137 1755022.630 1643811.562 1594908.427 1579015.317 Final consumption - energy use
35637 Final consumption - energy use Total Terajoule Ukraine 1849905.636 1963041.095 2027153.668 1982273.606 2044254.858 1988233.954 ... 3142668.197 3453304.235 3634193.392 3805233.320 3864933.924 4547103.552 5413258.133 6058287.220 6016449.244 Final consumption - energy use
35638 Final consumption - energy use Total Terajoule United Kingdom NaN 5083381.556 5132333.922 5063965.885 5103126.882 5026811.971 ... 5720050.390 5689514.395 5823053.560 5512475.275 5532421.580 5536860.610 5449510.400 5552469.776 5308638.346 Final consumption - energy use
35639 Final consumption - energy use Total Terajoule Kosovo (under United Nations Security Council ... 63835.024 63435.505 61588.912 63474.561 59998.375 56100.101 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN Final consumption - energy use

126 rows × 36 columns

nrg_bal siec unit geo 2020 2019 2018 2017 2016 2015 ... 1998 1997 1996 1995 1994 1993 1992 1991 1990 nrg_bal_obj
35514 Final consumption - energy use Total Gigawatt-hour Albania 2.147405e+04 2.387681e+04 2.482088e+04 2.417794e+04 2.209186e+04 2.282385e+04 ... 1.071961e+04 9.611654e+03 1.192866e+04 1.103705e+04 1.091237e+04 1.092246e+04 1.188951e+04 1.637133e+04 22265.844 Final consumption - energy use
35515 Final consumption - energy use Total Gigawatt-hour Austria 2.886249e+05 3.050272e+05 3.028303e+05 3.082321e+05 3.035423e+05 2.962904e+05 ... 2.504159e+05 2.430086e+05 2.489590e+05 2.290920e+05 2.188852e+05 2.241146e+05 2.200611e+05 2.257377e+05 208914.111 Final consumption - energy use
35516 Final consumption - energy use Total Gigawatt-hour Bosnia and Herzegovina 4.680481e+04 4.893541e+04 4.898475e+04 4.068096e+04 4.121595e+04 3.857563e+04 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN Final consumption - energy use
35517 Final consumption - energy use Total Gigawatt-hour Belgium 3.609855e+05 3.789032e+05 3.859293e+05 3.833954e+05 3.887567e+05 3.855334e+05 ... 3.875432e+05 3.793463e+05 3.871374e+05 3.635328e+05 3.536828e+05 3.471300e+05 3.509169e+05 3.482009e+05 330464.804 Final consumption - energy use
35518 Final consumption - energy use Total Gigawatt-hour Bulgaria 1.106332e+05 1.128898e+05 1.134521e+05 1.133449e+05 1.106938e+05 1.091889e+05 ... 1.150743e+05 1.184308e+05 1.281320e+05 1.247602e+05 1.186115e+05 1.180978e+05 1.219376e+05 1.385566e+05 185601.676 Final consumption - energy use
35519 Final consumption - energy use Total Gigawatt-hour Cyprus 1.777713e+04 1.891797e+04 1.839021e+04 1.804448e+04 1.733575e+04 1.656022e+04 ... 1.486154e+04 1.420454e+04 1.413870e+04 1.339741e+04 1.283463e+04 1.236588e+04 1.201241e+04 1.154712e+04 9920.896 Final consumption - energy use
35520 Final consumption - energy use Total Gigawatt-hour Czechia 2.762517e+05 2.817057e+05 2.812842e+05 2.842431e+05 2.755215e+05 2.685820e+05 ... 2.812574e+05 2.922413e+05 2.960390e+05 2.913721e+05 2.946954e+05 3.146788e+05 3.225512e+05 3.264464e+05 362561.850 Final consumption - energy use
35521 Final consumption - energy use Total Gigawatt-hour Germany (until 1990 former territory of the FRG) 2.251765e+06 2.335354e+06 2.333962e+06 2.378478e+06 2.368647e+06 2.326364e+06 ... 2.490197e+06 2.508348e+06 2.560695e+06 2.449186e+06 2.410843e+06 2.467317e+06 2.447989e+06 2.526766e+06 2543117.158 Final consumption - energy use
35522 Final consumption - energy use Total Gigawatt-hour Denmark 1.527109e+05 1.575483e+05 1.605762e+05 1.606873e+05 1.600788e+05 1.565707e+05 ... 1.675543e+05 1.684460e+05 1.725896e+05 1.659242e+05 1.625817e+05 1.628754e+05 1.572489e+05 1.596496e+05 150321.500 Final consumption - energy use
35523 Final consumption - energy use Total Gigawatt-hour Euro area - 19 countries (from 2015) 8.026523e+06 8.591978e+06 8.630465e+06 8.650930e+06 8.580933e+06 8.445910e+06 ... 8.590815e+06 8.438200e+06 8.510953e+06 8.156643e+06 7.993518e+06 8.067753e+06 8.081861e+06 8.237822e+06 8038571.044 Final consumption - energy use
35524 Final consumption - energy use Total Gigawatt-hour Estonia 3.171289e+04 3.283487e+04 3.357908e+04 3.265022e+04 3.250393e+04 3.198652e+04 ... 3.047385e+04 3.300872e+04 3.350431e+04 3.044602e+04 3.349649e+04 3.394519e+04 3.982271e+04 6.054126e+04 61635.383 Final consumption - energy use
35525 Final consumption - energy use Total Gigawatt-hour Greece 1.684356e+05 1.791147e+05 1.762236e+05 1.828326e+05 1.846748e+05 1.830681e+05 ... 2.035356e+05 1.935275e+05 1.873095e+05 1.739744e+05 1.689243e+05 1.670120e+05 1.670857e+05 1.663802e+05 161522.031 Final consumption - energy use
35526 Final consumption - energy use Total Gigawatt-hour Spain 8.411195e+05 9.480054e+05 9.500465e+05 9.268168e+05 9.028012e+05 8.831969e+05 ... 8.003951e+05 7.588725e+05 7.303725e+05 7.120866e+05 6.965213e+05 6.644025e+05 6.746716e+05 6.657050e+05 639071.473 Final consumption - energy use
35527 Final consumption - energy use Total Gigawatt-hour European Union - 27 countries (from 2020) 1.030144e+07 1.090728e+07 1.096271e+07 1.093903e+07 1.078970e+07 1.057690e+07 ... 1.077815e+07 1.071937e+07 1.084762e+07 1.038030e+07 1.017115e+07 1.028110e+07 1.026696e+07 1.057149e+07 10541716.928 Final consumption - energy use
35528 Final consumption - energy use Total Gigawatt-hour Finland 2.697122e+05 2.875925e+05 2.908084e+05 2.862548e+05 2.792502e+05 2.680598e+05 ... 2.697287e+05 2.600511e+05 2.530168e+05 2.479180e+05 2.518300e+05 2.394032e+05 2.387067e+05 2.390818e+05 243731.869 Final consumption - energy use
35529 Final consumption - energy use Total Gigawatt-hour France 1.490605e+06 1.618097e+06 1.631976e+06 1.655446e+06 1.667843e+06 1.638289e+06 ... 1.659064e+06 1.614908e+06 1.645338e+06 1.568397e+06 1.552052e+06 1.586767e+06 1.598382e+06 1.592492e+06 1487575.009 Final consumption - energy use
35530 Final consumption - energy use Total Gigawatt-hour Georgia 4.871598e+04 4.961983e+04 4.832384e+04 4.899021e+04 4.844675e+04 4.557975e+04 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN Final consumption - energy use
35531 Final consumption - energy use Total Gigawatt-hour Croatia 7.480401e+04 7.822786e+04 7.771741e+04 7.899793e+04 7.596326e+04 7.541298e+04 ... 6.891660e+04 6.790911e+04 6.347714e+04 6.051058e+04 5.845763e+04 5.796455e+04 5.649533e+04 6.462468e+04 73552.207 Final consumption - energy use
35532 Final consumption - energy use Total Gigawatt-hour Hungary 2.047057e+05 2.089869e+05 2.075883e+05 2.078806e+05 2.012724e+05 1.957286e+05 ... 1.818424e+05 1.813010e+05 1.883837e+05 1.816381e+05 1.810531e+05 1.827961e+05 1.837541e+05 2.100137e+05 220533.708 Final consumption - energy use
35533 Final consumption - energy use Total Gigawatt-hour Ireland 1.260714e+05 1.316169e+05 1.318343e+05 1.264356e+05 1.270123e+05 1.222608e+05 ... 1.035421e+05 9.543910e+04 9.251442e+04 8.830060e+04 8.683184e+04 8.323416e+04 8.181654e+04 8.260737e+04 81124.621 Final consumption - energy use
35534 Final consumption - energy use Total Gigawatt-hour Iceland 3.337507e+04 3.412816e+04 3.580736e+04 3.313336e+04 3.257991e+04 3.312949e+04 ... 1.816958e+04 1.747741e+04 1.737394e+04 1.654036e+04 1.663806e+04 1.612372e+04 1.574354e+04 1.533843e+04 15532.594 Final consumption - energy use
35535 Final consumption - energy use Total Gigawatt-hour Italy 1.198555e+06 1.315579e+06 1.329273e+06 1.321298e+06 1.297380e+06 1.303818e+06 ... 1.344982e+06 1.306361e+06 1.298529e+06 1.284979e+06 1.229937e+06 1.251051e+06 1.246943e+06 1.245949e+06 1215594.769 Final consumption - energy use
35536 Final consumption - energy use Total Gigawatt-hour Lithuania 6.145538e+04 6.350004e+04 6.357633e+04 6.093052e+04 5.818739e+04 5.558570e+04 ... 5.164174e+04 5.215784e+04 5.166235e+04 5.291757e+04 5.452725e+04 5.659518e+04 7.329007e+04 1.162271e+05 110934.731 Final consumption - energy use
35537 Final consumption - energy use Total Gigawatt-hour Luxembourg 3.797747e+04 4.408183e+04 4.345800e+04 4.195657e+04 4.109266e+04 4.110675e+04 ... 3.322511e+04 3.316702e+04 3.297558e+04 3.184453e+04 3.502282e+04 3.575801e+04 3.489013e+04 3.450374e+04 31951.614 Final consumption - energy use
35538 Final consumption - energy use Total Gigawatt-hour Latvia 4.417289e+04 4.564411e+04 4.680802e+04 4.506852e+04 4.300126e+04 4.280034e+04 ... 4.147083e+04 4.289984e+04 4.368348e+04 4.446478e+04 4.697200e+04 5.179101e+04 5.969127e+04 7.164783e+04 73790.217 Final consumption - energy use
35539 Final consumption - energy use Total Gigawatt-hour Moldova 2.944976e+04 3.002370e+04 3.143119e+04 3.011963e+04 2.858560e+04 2.741305e+04 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN Final consumption - energy use
35540 Final consumption - energy use Total Gigawatt-hour Montenegro 8.104252e+03 8.846073e+03 8.485630e+03 8.476975e+03 8.010292e+03 7.706547e+03 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN Final consumption - energy use
35541 Final consumption - energy use Total Gigawatt-hour North Macedonia 2.121225e+04 2.253682e+04 2.131501e+04 2.161971e+04 2.148914e+04 2.137116e+04 ... 1.858965e+04 1.904029e+04 2.094384e+04 1.675511e+04 1.732379e+04 1.940255e+04 1.827676e+04 1.575252e+04 16698.489 Final consumption - energy use
35542 Final consumption - energy use Total Gigawatt-hour Malta 5.813549e+03 6.332057e+03 5.969271e+03 5.726382e+03 5.335369e+03 5.377052e+03 ... 4.349944e+03 4.771694e+03 4.066861e+03 4.421444e+03 3.958250e+03 4.013250e+03 3.731056e+03 3.580028e+03 3057.167 Final consumption - energy use
35543 Final consumption - energy use Total Gigawatt-hour Netherlands 4.915046e+05 5.154087e+05 5.250528e+05 5.195935e+05 5.174583e+05 5.059502e+05 ... 5.547905e+05 5.553624e+05 5.920308e+05 5.447295e+05 5.272853e+05 5.377913e+05 5.207394e+05 5.291880e+05 499903.361 Final consumption - energy use
35544 Final consumption - energy use Total Gigawatt-hour Norway 2.201394e+05 2.264483e+05 2.257772e+05 2.242912e+05 2.229664e+05 2.191933e+05 ... 2.063354e+05 1.971749e+05 1.977633e+05 1.923519e+05 1.878768e+05 1.828784e+05 1.781412e+05 1.794973e+05 181747.551 Final consumption - energy use
35545 Final consumption - energy use Total Gigawatt-hour Poland 8.170150e+05 8.360886e+05 8.499508e+05 8.052730e+05 7.575367e+05 7.078189e+05 ... 6.799591e+05 7.358981e+05 7.518212e+05 7.085172e+05 6.927095e+05 7.188618e+05 6.658885e+05 6.790758e+05 666446.112 Final consumption - energy use
35546 Final consumption - energy use Total Gigawatt-hour Portugal 1.769524e+05 1.902242e+05 1.878766e+05 1.849251e+05 1.819018e+05 1.808567e+05 ... 1.821122e+05 1.701365e+05 1.633680e+05 1.540990e+05 1.504055e+05 1.437498e+05 1.420244e+05 1.374756e+05 132294.442 Final consumption - energy use
35547 Final consumption - energy use Total Gigawatt-hour Romania 2.729838e+05 2.757782e+05 2.726629e+05 2.672592e+05 2.551070e+05 2.512108e+05 ... 2.927171e+05 3.205971e+05 3.323653e+05 2.980492e+05 2.850168e+05 2.790917e+05 3.018591e+05 3.995849e+05 493077.532 Final consumption - energy use
35548 Final consumption - energy use Total Gigawatt-hour Serbia 1.006965e+05 9.723847e+04 9.809946e+04 9.726446e+04 9.544079e+04 9.171285e+04 ... 1.076979e+05 1.103899e+05 1.007200e+05 7.000066e+04 7.300921e+04 7.657531e+04 9.201646e+04 1.120885e+05 134896.698 Final consumption - energy use
35549 Final consumption - energy use Total Gigawatt-hour Sweden 3.658137e+05 3.640751e+05 3.690106e+05 3.704137e+05 3.725982e+05 3.664723e+05 ... 4.000094e+05 3.963430e+05 4.038635e+05 3.928846e+05 3.845077e+05 3.789826e+05 3.753644e+05 3.557178e+05 351051.299 Final consumption - energy use
35550 Final consumption - energy use Total Gigawatt-hour Slovenia 5.150740e+04 5.655459e+04 5.760022e+04 5.767294e+04 5.691324e+04 5.483828e+04 ... 5.065021e+04 5.267622e+04 5.183845e+04 4.725948e+04 4.468814e+04 4.249461e+04 3.928173e+04 4.291583e+04 42960.273 Final consumption - energy use
35551 Final consumption - energy use Total Gigawatt-hour Slovakia 1.117750e+05 1.191889e+05 1.152709e+05 1.151722e+05 1.072953e+05 1.039684e+05 ... 1.178349e+05 1.199537e+05 1.198131e+05 1.155964e+05 1.148206e+05 1.188170e+05 1.298049e+05 1.372765e+05 161007.115 Final consumption - energy use
35552 Final consumption - energy use Total Gigawatt-hour Türkiye 1.176293e+06 1.152535e+06 1.147102e+06 1.168524e+06 1.050400e+06 1.010030e+06 ... 5.713938e+05 5.766418e+05 5.593027e+05 5.137402e+05 4.670945e+05 4.875063e+05 4.566143e+05 4.430301e+05 438615.366 Final consumption - energy use
35553 Final consumption - energy use Total Gigawatt-hour Ukraine 5.138627e+05 5.452892e+05 5.630982e+05 5.506316e+05 5.678486e+05 5.522872e+05 ... 8.729634e+05 9.592512e+05 1.009498e+06 1.057009e+06 1.073593e+06 1.263084e+06 1.503683e+06 1.682858e+06 1671235.901 Final consumption - energy use
35554 Final consumption - energy use Total Gigawatt-hour United Kingdom NaN 1.412050e+06 1.425648e+06 1.406657e+06 1.417535e+06 1.396337e+06 ... 1.588903e+06 1.580421e+06 1.617515e+06 1.531243e+06 1.536784e+06 1.538017e+06 1.513753e+06 1.542353e+06 1474621.763 Final consumption - energy use
35555 Final consumption - energy use Total Gigawatt-hour Kosovo (under United Nations Security Council ... 1.773195e+04 1.762097e+04 1.710803e+04 1.763182e+04 1.666622e+04 1.558336e+04 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN Final consumption - energy use

42 rows × 36 columns

geo 2020 2019 2018 2017 2016 2015 2014 2013 2012
35514 Albania 2.147405e+04 2.387681e+04 2.482088e+04 2.417794e+04 2.209186e+04 2.282385e+04 2.394122e+04 2.281655e+04 2.082494e+04
35515 Austria 2.886249e+05 3.050272e+05 3.028303e+05 3.082321e+05 3.035423e+05 2.962904e+05 2.879859e+05 3.000607e+05 2.931221e+05
35516 Bosnia and Herzegovina 4.680481e+04 4.893541e+04 4.898475e+04 4.068096e+04 4.121595e+04 3.857563e+04 3.609515e+04 NaN NaN
35517 Belgium 3.609855e+05 3.789032e+05 3.859293e+05 3.833954e+05 3.887567e+05 3.855334e+05 3.672835e+05 3.961131e+05 3.838927e+05
35518 Bulgaria 1.106332e+05 1.128898e+05 1.134521e+05 1.133449e+05 1.106938e+05 1.091889e+05 1.032919e+05 1.009572e+05 1.058722e+05
35519 Cyprus 1.777713e+04 1.891797e+04 1.839021e+04 1.804448e+04 1.733575e+04 1.656022e+04 1.601855e+04 1.596165e+04 1.736125e+04
35520 Czechia 2.762517e+05 2.817057e+05 2.812842e+05 2.842431e+05 2.755215e+05 2.685820e+05 2.609707e+05 2.689594e+05 2.712320e+05
35521 Germany (until 1990 former territory of the FRG) 2.251765e+06 2.335354e+06 2.333962e+06 2.378478e+06 2.368647e+06 2.326364e+06 2.293773e+06 2.419708e+06 2.356965e+06
35522 Denmark 1.527109e+05 1.575483e+05 1.605762e+05 1.606873e+05 1.600788e+05 1.565707e+05 1.504057e+05 1.565516e+05 1.583135e+05
35523 Euro area - 19 countries (from 2015) 8.026523e+06 8.591978e+06 8.630465e+06 8.650930e+06 8.580933e+06 8.445910e+06 8.279002e+06 8.704211e+06 8.682039e+06
35524 Estonia 3.171289e+04 3.283487e+04 3.357908e+04 3.265022e+04 3.250393e+04 3.198652e+04 3.226567e+04 3.303287e+04 3.288063e+04
35525 Greece 1.684356e+05 1.791147e+05 1.762236e+05 1.828326e+05 1.846748e+05 1.830681e+05 1.721718e+05 1.705928e+05 1.907667e+05
35526 Spain 8.411195e+05 9.480054e+05 9.500465e+05 9.268168e+05 9.028012e+05 8.831969e+05 8.738606e+05 8.844630e+05 9.187129e+05
35527 European Union - 27 countries (from 2020) 1.030144e+07 1.090728e+07 1.096271e+07 1.093903e+07 1.078970e+07 1.057690e+07 1.035801e+07 1.083716e+07 1.085452e+07
35528 Finland 2.697122e+05 2.875925e+05 2.908084e+05 2.862548e+05 2.792502e+05 2.680598e+05 2.723141e+05 2.740162e+05 2.784223e+05
35529 France 1.490605e+06 1.618097e+06 1.631976e+06 1.655446e+06 1.667843e+06 1.638289e+06 1.601584e+06 1.730701e+06 1.698671e+06
35530 Georgia 4.871598e+04 4.961983e+04 4.832384e+04 4.899021e+04 4.844675e+04 4.557975e+04 4.415705e+04 4.076871e+04 NaN
35531 Croatia 7.480401e+04 7.822786e+04 7.771741e+04 7.899793e+04 7.596326e+04 7.541298e+04 7.130089e+04 7.522327e+04 7.628887e+04
35532 Hungary 2.047057e+05 2.089869e+05 2.075883e+05 2.078806e+05 2.012724e+05 1.957286e+05 1.834715e+05 1.890507e+05 1.861211e+05
35533 Ireland 1.260714e+05 1.316169e+05 1.318343e+05 1.264356e+05 1.270123e+05 1.222608e+05 1.185041e+05 1.191711e+05 1.183193e+05
35534 Iceland 3.337507e+04 3.412816e+04 3.580736e+04 3.313336e+04 3.257991e+04 3.312949e+04 3.186274e+04 3.147922e+04 3.024369e+04
35535 Italy 1.198555e+06 1.315579e+06 1.329273e+06 1.321298e+06 1.297380e+06 1.303818e+06 1.265906e+06 1.326444e+06 1.355582e+06
35536 Lithuania 6.145538e+04 6.350004e+04 6.357633e+04 6.093052e+04 5.818739e+04 5.558570e+04 5.583024e+04 5.480411e+04 5.627720e+04
35537 Luxembourg 3.797747e+04 4.408183e+04 4.345800e+04 4.195657e+04 4.109266e+04 4.110675e+04 4.182826e+04 4.364850e+04 4.418514e+04
35538 Latvia 4.417289e+04 4.564411e+04 4.680802e+04 4.506852e+04 4.300126e+04 4.280034e+04 4.391564e+04 4.340601e+04 4.545331e+04
35539 Moldova 2.944976e+04 3.002370e+04 3.143119e+04 3.011963e+04 2.858560e+04 2.741305e+04 2.669239e+04 2.668376e+04 2.637589e+04
35540 Montenegro 8.104252e+03 8.846073e+03 8.485630e+03 8.476975e+03 8.010292e+03 7.706547e+03 7.310322e+03 7.454722e+03 8.129025e+03
35541 North Macedonia 2.121225e+04 2.253682e+04 2.131501e+04 2.161971e+04 2.148914e+04 2.137116e+04 2.090470e+04 2.110615e+04 2.146542e+04
35542 Malta 5.813549e+03 6.332057e+03 5.969271e+03 5.726382e+03 5.335369e+03 5.377052e+03 5.067378e+03 4.897551e+03 4.736402e+03
35543 Netherlands 4.915046e+05 5.154087e+05 5.250528e+05 5.195935e+05 5.174583e+05 5.059502e+05 4.965057e+05 5.484708e+05 5.468634e+05
35544 Norway 2.201394e+05 2.264483e+05 2.257772e+05 2.242912e+05 2.229664e+05 2.191933e+05 2.164709e+05 2.212629e+05 2.213105e+05
35545 Poland 8.170150e+05 8.360886e+05 8.499508e+05 8.052730e+05 7.575367e+05 7.078189e+05 7.001656e+05 7.222959e+05 7.356891e+05
35546 Portugal 1.769524e+05 1.902242e+05 1.878766e+05 1.849251e+05 1.819018e+05 1.808567e+05 1.789437e+05 1.733837e+05 1.757478e+05
35547 Romania 2.729838e+05 2.757782e+05 2.726629e+05 2.672592e+05 2.551070e+05 2.512108e+05 2.497004e+05 2.515723e+05 2.631772e+05
35548 Serbia 1.006965e+05 9.723847e+04 9.809946e+04 9.726446e+04 9.544079e+04 9.171285e+04 8.933715e+04 9.538555e+04 9.783497e+04
35549 Sweden 3.658137e+05 3.640751e+05 3.690106e+05 3.704137e+05 3.725982e+05 3.664723e+05 3.597022e+05 3.683405e+05 3.757836e+05
35550 Slovenia 5.150740e+04 5.655459e+04 5.760022e+04 5.767294e+04 5.691324e+04 5.483828e+04 5.359122e+04 5.587319e+04 5.710118e+04
35551 Slovakia 1.117750e+05 1.191889e+05 1.152709e+05 1.151722e+05 1.072953e+05 1.039684e+05 1.016519e+05 1.094630e+05 1.069781e+05
35552 Türkiye 1.176293e+06 1.152535e+06 1.147102e+06 1.168524e+06 1.050400e+06 1.010030e+06 9.402191e+05 9.125687e+05 9.206124e+05
35553 Ukraine 5.138627e+05 5.452892e+05 5.630982e+05 5.506316e+05 5.678486e+05 5.522872e+05 6.733052e+05 7.576255e+05 7.722794e+05
35554 United Kingdom NaN 1.412050e+06 1.425648e+06 1.406657e+06 1.417535e+06 1.396337e+06 1.355989e+06 1.435089e+06 1.426519e+06
35555 Kosovo (under United Nations Security Council ... 1.773195e+04 1.762097e+04 1.710803e+04 1.763182e+04 1.666622e+04 1.558336e+04 1.431305e+04 1.357893e+04 1.418129e+04
geo 2020 2019 2018 2017 2016 2015 2014 2013 2012
0 Albania 2.147405e+04 2.387681e+04 2.482088e+04 2.417794e+04 2.209186e+04 2.282385e+04 2.394122e+04 2.281655e+04 2.082494e+04
1 Austria 2.886249e+05 3.050272e+05 3.028303e+05 3.082321e+05 3.035423e+05 2.962904e+05 2.879859e+05 3.000607e+05 2.931221e+05
2 Bosnia and Herzegovina 4.680481e+04 4.893541e+04 4.898475e+04 4.068096e+04 4.121595e+04 3.857563e+04 3.609515e+04 NaN NaN
3 Belgium 3.609855e+05 3.789032e+05 3.859293e+05 3.833954e+05 3.887567e+05 3.855334e+05 3.672835e+05 3.961131e+05 3.838927e+05
4 Bulgaria 1.106332e+05 1.128898e+05 1.134521e+05 1.133449e+05 1.106938e+05 1.091889e+05 1.032919e+05 1.009572e+05 1.058722e+05
5 Cyprus 1.777713e+04 1.891797e+04 1.839021e+04 1.804448e+04 1.733575e+04 1.656022e+04 1.601855e+04 1.596165e+04 1.736125e+04
6 Czechia 2.762517e+05 2.817057e+05 2.812842e+05 2.842431e+05 2.755215e+05 2.685820e+05 2.609707e+05 2.689594e+05 2.712320e+05
7 Germany (until 1990 former territory of the FRG) 2.251765e+06 2.335354e+06 2.333962e+06 2.378478e+06 2.368647e+06 2.326364e+06 2.293773e+06 2.419708e+06 2.356965e+06
8 Denmark 1.527109e+05 1.575483e+05 1.605762e+05 1.606873e+05 1.600788e+05 1.565707e+05 1.504057e+05 1.565516e+05 1.583135e+05
9 Euro area - 19 countries (from 2015) 8.026523e+06 8.591978e+06 8.630465e+06 8.650930e+06 8.580933e+06 8.445910e+06 8.279002e+06 8.704211e+06 8.682039e+06
10 Estonia 3.171289e+04 3.283487e+04 3.357908e+04 3.265022e+04 3.250393e+04 3.198652e+04 3.226567e+04 3.303287e+04 3.288063e+04
11 Greece 1.684356e+05 1.791147e+05 1.762236e+05 1.828326e+05 1.846748e+05 1.830681e+05 1.721718e+05 1.705928e+05 1.907667e+05
12 Spain 8.411195e+05 9.480054e+05 9.500465e+05 9.268168e+05 9.028012e+05 8.831969e+05 8.738606e+05 8.844630e+05 9.187129e+05
13 European Union - 27 countries (from 2020) 1.030144e+07 1.090728e+07 1.096271e+07 1.093903e+07 1.078970e+07 1.057690e+07 1.035801e+07 1.083716e+07 1.085452e+07
14 Finland 2.697122e+05 2.875925e+05 2.908084e+05 2.862548e+05 2.792502e+05 2.680598e+05 2.723141e+05 2.740162e+05 2.784223e+05
15 France 1.490605e+06 1.618097e+06 1.631976e+06 1.655446e+06 1.667843e+06 1.638289e+06 1.601584e+06 1.730701e+06 1.698671e+06
16 Georgia 4.871598e+04 4.961983e+04 4.832384e+04 4.899021e+04 4.844675e+04 4.557975e+04 4.415705e+04 4.076871e+04 NaN
17 Croatia 7.480401e+04 7.822786e+04 7.771741e+04 7.899793e+04 7.596326e+04 7.541298e+04 7.130089e+04 7.522327e+04 7.628887e+04
18 Hungary 2.047057e+05 2.089869e+05 2.075883e+05 2.078806e+05 2.012724e+05 1.957286e+05 1.834715e+05 1.890507e+05 1.861211e+05
19 Ireland 1.260714e+05 1.316169e+05 1.318343e+05 1.264356e+05 1.270123e+05 1.222608e+05 1.185041e+05 1.191711e+05 1.183193e+05
20 Iceland 3.337507e+04 3.412816e+04 3.580736e+04 3.313336e+04 3.257991e+04 3.312949e+04 3.186274e+04 3.147922e+04 3.024369e+04
21 Italy 1.198555e+06 1.315579e+06 1.329273e+06 1.321298e+06 1.297380e+06 1.303818e+06 1.265906e+06 1.326444e+06 1.355582e+06
22 Lithuania 6.145538e+04 6.350004e+04 6.357633e+04 6.093052e+04 5.818739e+04 5.558570e+04 5.583024e+04 5.480411e+04 5.627720e+04
23 Luxembourg 3.797747e+04 4.408183e+04 4.345800e+04 4.195657e+04 4.109266e+04 4.110675e+04 4.182826e+04 4.364850e+04 4.418514e+04
24 Latvia 4.417289e+04 4.564411e+04 4.680802e+04 4.506852e+04 4.300126e+04 4.280034e+04 4.391564e+04 4.340601e+04 4.545331e+04
25 Moldova 2.944976e+04 3.002370e+04 3.143119e+04 3.011963e+04 2.858560e+04 2.741305e+04 2.669239e+04 2.668376e+04 2.637589e+04
26 Montenegro 8.104252e+03 8.846073e+03 8.485630e+03 8.476975e+03 8.010292e+03 7.706547e+03 7.310322e+03 7.454722e+03 8.129025e+03
27 North Macedonia 2.121225e+04 2.253682e+04 2.131501e+04 2.161971e+04 2.148914e+04 2.137116e+04 2.090470e+04 2.110615e+04 2.146542e+04
28 Malta 5.813549e+03 6.332057e+03 5.969271e+03 5.726382e+03 5.335369e+03 5.377052e+03 5.067378e+03 4.897551e+03 4.736402e+03
29 Netherlands 4.915046e+05 5.154087e+05 5.250528e+05 5.195935e+05 5.174583e+05 5.059502e+05 4.965057e+05 5.484708e+05 5.468634e+05
30 Norway 2.201394e+05 2.264483e+05 2.257772e+05 2.242912e+05 2.229664e+05 2.191933e+05 2.164709e+05 2.212629e+05 2.213105e+05
31 Poland 8.170150e+05 8.360886e+05 8.499508e+05 8.052730e+05 7.575367e+05 7.078189e+05 7.001656e+05 7.222959e+05 7.356891e+05
32 Portugal 1.769524e+05 1.902242e+05 1.878766e+05 1.849251e+05 1.819018e+05 1.808567e+05 1.789437e+05 1.733837e+05 1.757478e+05
33 Romania 2.729838e+05 2.757782e+05 2.726629e+05 2.672592e+05 2.551070e+05 2.512108e+05 2.497004e+05 2.515723e+05 2.631772e+05
34 Serbia 1.006965e+05 9.723847e+04 9.809946e+04 9.726446e+04 9.544079e+04 9.171285e+04 8.933715e+04 9.538555e+04 9.783497e+04
35 Sweden 3.658137e+05 3.640751e+05 3.690106e+05 3.704137e+05 3.725982e+05 3.664723e+05 3.597022e+05 3.683405e+05 3.757836e+05
36 Slovenia 5.150740e+04 5.655459e+04 5.760022e+04 5.767294e+04 5.691324e+04 5.483828e+04 5.359122e+04 5.587319e+04 5.710118e+04
37 Slovakia 1.117750e+05 1.191889e+05 1.152709e+05 1.151722e+05 1.072953e+05 1.039684e+05 1.016519e+05 1.094630e+05 1.069781e+05
38 Türkiye 1.176293e+06 1.152535e+06 1.147102e+06 1.168524e+06 1.050400e+06 1.010030e+06 9.402191e+05 9.125687e+05 9.206124e+05
39 Ukraine 5.138627e+05 5.452892e+05 5.630982e+05 5.506316e+05 5.678486e+05 5.522872e+05 6.733052e+05 7.576255e+05 7.722794e+05
40 United Kingdom NaN 1.412050e+06 1.425648e+06 1.406657e+06 1.417535e+06 1.396337e+06 1.355989e+06 1.435089e+06 1.426519e+06
41 Kosovo (under United Nations Security Council ... 1.773195e+04 1.762097e+04 1.710803e+04 1.763182e+04 1.666622e+04 1.558336e+04 1.431305e+04 1.357893e+04 1.418129e+04
2020 2019 2018 2017 2016 2015 2014 2013 2012
geo
Albania 2.147405e+04 2.387681e+04 2.482088e+04 2.417794e+04 2.209186e+04 2.282385e+04 2.394122e+04 2.281655e+04 2.082494e+04
Austria 2.886249e+05 3.050272e+05 3.028303e+05 3.082321e+05 3.035423e+05 2.962904e+05 2.879859e+05 3.000607e+05 2.931221e+05
Bosnia and Herzegovina 4.680481e+04 4.893541e+04 4.898475e+04 4.068096e+04 4.121595e+04 3.857563e+04 3.609515e+04 NaN NaN
Belgium 3.609855e+05 3.789032e+05 3.859293e+05 3.833954e+05 3.887567e+05 3.855334e+05 3.672835e+05 3.961131e+05 3.838927e+05
Bulgaria 1.106332e+05 1.128898e+05 1.134521e+05 1.133449e+05 1.106938e+05 1.091889e+05 1.032919e+05 1.009572e+05 1.058722e+05
Cyprus 1.777713e+04 1.891797e+04 1.839021e+04 1.804448e+04 1.733575e+04 1.656022e+04 1.601855e+04 1.596165e+04 1.736125e+04
Czechia 2.762517e+05 2.817057e+05 2.812842e+05 2.842431e+05 2.755215e+05 2.685820e+05 2.609707e+05 2.689594e+05 2.712320e+05
Germany (until 1990 former territory of the FRG) 2.251765e+06 2.335354e+06 2.333962e+06 2.378478e+06 2.368647e+06 2.326364e+06 2.293773e+06 2.419708e+06 2.356965e+06
Denmark 1.527109e+05 1.575483e+05 1.605762e+05 1.606873e+05 1.600788e+05 1.565707e+05 1.504057e+05 1.565516e+05 1.583135e+05
Euro area - 19 countries (from 2015) 8.026523e+06 8.591978e+06 8.630465e+06 8.650930e+06 8.580933e+06 8.445910e+06 8.279002e+06 8.704211e+06 8.682039e+06
Estonia 3.171289e+04 3.283487e+04 3.357908e+04 3.265022e+04 3.250393e+04 3.198652e+04 3.226567e+04 3.303287e+04 3.288063e+04
Greece 1.684356e+05 1.791147e+05 1.762236e+05 1.828326e+05 1.846748e+05 1.830681e+05 1.721718e+05 1.705928e+05 1.907667e+05
Spain 8.411195e+05 9.480054e+05 9.500465e+05 9.268168e+05 9.028012e+05 8.831969e+05 8.738606e+05 8.844630e+05 9.187129e+05
European Union - 27 countries (from 2020) 1.030144e+07 1.090728e+07 1.096271e+07 1.093903e+07 1.078970e+07 1.057690e+07 1.035801e+07 1.083716e+07 1.085452e+07
Finland 2.697122e+05 2.875925e+05 2.908084e+05 2.862548e+05 2.792502e+05 2.680598e+05 2.723141e+05 2.740162e+05 2.784223e+05
France 1.490605e+06 1.618097e+06 1.631976e+06 1.655446e+06 1.667843e+06 1.638289e+06 1.601584e+06 1.730701e+06 1.698671e+06
Georgia 4.871598e+04 4.961983e+04 4.832384e+04 4.899021e+04 4.844675e+04 4.557975e+04 4.415705e+04 4.076871e+04 NaN
Croatia 7.480401e+04 7.822786e+04 7.771741e+04 7.899793e+04 7.596326e+04 7.541298e+04 7.130089e+04 7.522327e+04 7.628887e+04
Hungary 2.047057e+05 2.089869e+05 2.075883e+05 2.078806e+05 2.012724e+05 1.957286e+05 1.834715e+05 1.890507e+05 1.861211e+05
Ireland 1.260714e+05 1.316169e+05 1.318343e+05 1.264356e+05 1.270123e+05 1.222608e+05 1.185041e+05 1.191711e+05 1.183193e+05
Iceland 3.337507e+04 3.412816e+04 3.580736e+04 3.313336e+04 3.257991e+04 3.312949e+04 3.186274e+04 3.147922e+04 3.024369e+04
Italy 1.198555e+06 1.315579e+06 1.329273e+06 1.321298e+06 1.297380e+06 1.303818e+06 1.265906e+06 1.326444e+06 1.355582e+06
Lithuania 6.145538e+04 6.350004e+04 6.357633e+04 6.093052e+04 5.818739e+04 5.558570e+04 5.583024e+04 5.480411e+04 5.627720e+04
Luxembourg 3.797747e+04 4.408183e+04 4.345800e+04 4.195657e+04 4.109266e+04 4.110675e+04 4.182826e+04 4.364850e+04 4.418514e+04
Latvia 4.417289e+04 4.564411e+04 4.680802e+04 4.506852e+04 4.300126e+04 4.280034e+04 4.391564e+04 4.340601e+04 4.545331e+04
Moldova 2.944976e+04 3.002370e+04 3.143119e+04 3.011963e+04 2.858560e+04 2.741305e+04 2.669239e+04 2.668376e+04 2.637589e+04
Montenegro 8.104252e+03 8.846073e+03 8.485630e+03 8.476975e+03 8.010292e+03 7.706547e+03 7.310322e+03 7.454722e+03 8.129025e+03
North Macedonia 2.121225e+04 2.253682e+04 2.131501e+04 2.161971e+04 2.148914e+04 2.137116e+04 2.090470e+04 2.110615e+04 2.146542e+04
Malta 5.813549e+03 6.332057e+03 5.969271e+03 5.726382e+03 5.335369e+03 5.377052e+03 5.067378e+03 4.897551e+03 4.736402e+03
Netherlands 4.915046e+05 5.154087e+05 5.250528e+05 5.195935e+05 5.174583e+05 5.059502e+05 4.965057e+05 5.484708e+05 5.468634e+05
Norway 2.201394e+05 2.264483e+05 2.257772e+05 2.242912e+05 2.229664e+05 2.191933e+05 2.164709e+05 2.212629e+05 2.213105e+05
Poland 8.170150e+05 8.360886e+05 8.499508e+05 8.052730e+05 7.575367e+05 7.078189e+05 7.001656e+05 7.222959e+05 7.356891e+05
Portugal 1.769524e+05 1.902242e+05 1.878766e+05 1.849251e+05 1.819018e+05 1.808567e+05 1.789437e+05 1.733837e+05 1.757478e+05
Romania 2.729838e+05 2.757782e+05 2.726629e+05 2.672592e+05 2.551070e+05 2.512108e+05 2.497004e+05 2.515723e+05 2.631772e+05
Serbia 1.006965e+05 9.723847e+04 9.809946e+04 9.726446e+04 9.544079e+04 9.171285e+04 8.933715e+04 9.538555e+04 9.783497e+04
Sweden 3.658137e+05 3.640751e+05 3.690106e+05 3.704137e+05 3.725982e+05 3.664723e+05 3.597022e+05 3.683405e+05 3.757836e+05
Slovenia 5.150740e+04 5.655459e+04 5.760022e+04 5.767294e+04 5.691324e+04 5.483828e+04 5.359122e+04 5.587319e+04 5.710118e+04
Slovakia 1.117750e+05 1.191889e+05 1.152709e+05 1.151722e+05 1.072953e+05 1.039684e+05 1.016519e+05 1.094630e+05 1.069781e+05
Türkiye 1.176293e+06 1.152535e+06 1.147102e+06 1.168524e+06 1.050400e+06 1.010030e+06 9.402191e+05 9.125687e+05 9.206124e+05
Ukraine 5.138627e+05 5.452892e+05 5.630982e+05 5.506316e+05 5.678486e+05 5.522872e+05 6.733052e+05 7.576255e+05 7.722794e+05
United Kingdom NaN 1.412050e+06 1.425648e+06 1.406657e+06 1.417535e+06 1.396337e+06 1.355989e+06 1.435089e+06 1.426519e+06
Kosovo (under United Nations Security Council Resolution 1244/99) 1.773195e+04 1.762097e+04 1.710803e+04 1.763182e+04 1.666622e+04 1.558336e+04 1.431305e+04 1.357893e+04 1.418129e+04
geo Albania Austria Bosnia and Herzegovina Belgium Bulgaria Cyprus Czechia Germany (until 1990 former territory of the FRG) Denmark Euro area - 19 countries (from 2015) ... Portugal Romania Serbia Sweden Slovenia Slovakia Türkiye Ukraine United Kingdom Kosovo (under United Nations Security Council Resolution 1244/99)
2020 21474.051 288624.871 46804.808 360985.528 110633.154 17777.130 276251.734 2251765.205 152710.872 8026522.519 ... 176952.427 272983.777 100696.470 365813.706 51507.402 111774.952 1176293.181 513862.677 NaN 17731.951
2019 23876.813 305027.230 48935.410 378903.241 112889.753 18917.965 281705.716 2335354.497 157548.312 8591977.931 ... 190224.237 275778.159 97238.474 364075.095 56554.593 119188.899 1152534.667 545289.193 1412050.432 17620.974
2018 24820.884 302830.312 48984.752 385929.337 113452.073 18390.206 281284.245 2333961.821 160576.170 8630465.209 ... 187876.587 272662.921 98099.457 369010.578 57600.223 115270.922 1147101.750 563098.241 1425648.312 17108.031
2017 24177.936 308232.060 40680.956 383395.441 113344.852 18044.478 284243.065 2378477.963 160687.340 8650930.437 ... 184925.111 267259.190 97264.464 370413.727 57672.936 115172.203 1168524.298 550631.557 1406657.190 17631.823
2016 22091.860 303542.303 41215.947 388756.658 110693.751 17335.750 275521.455 2368646.992 160078.788 8580932.636 ... 181901.796 255106.956 95440.788 372598.234 56913.244 107295.349 1050399.841 567848.572 1417535.245 16666.215
2015 22823.850 296290.399 38575.626 385533.434 109188.868 16560.224 268582.033 2326363.971 156570.676 8445910.093 ... 180856.675 251210.797 91712.848 366472.330 54838.275 103968.449 1010030.350 552287.209 1396336.659 15583.361
2014 23941.215 287985.855 36095.152 367283.461 103291.851 16018.554 260970.747 2293773.490 150405.746 8279001.860 ... 178943.690 249700.374 89337.149 359702.233 53591.224 101651.892 940219.127 673305.177 1355988.652 14313.046
2013 22816.554 300060.664 NaN 396113.064 100957.206 15961.653 268959.413 2419707.803 156551.560 8704211.429 ... 173383.735 251572.314 95385.555 368340.459 55873.193 109463.001 912568.698 757625.493 1435088.648 13578.934
2012 20824.945 293122.137 NaN 383892.650 105872.176 17361.253 271232.039 2356965.292 158313.544 8682038.597 ... 175747.771 263177.218 97834.969 375783.591 57101.178 106978.148 920612.405 772279.393 1426519.457 14181.294

9 rows × 42 columns

<class 'pandas.core.frame.DataFrame'>
Index: 42 entries, Albania to Kosovo (under United Nations Security Council Resolution 1244/99)
Data columns (total 9 columns):
 #   Column  Non-Null Count  Dtype  
---  ------  --------------  -----  
 0   2020    41 non-null     float64
 1   2019    42 non-null     float64
 2   2018    42 non-null     float64
 3   2017    42 non-null     float64
 4   2016    42 non-null     float64
 5   2015    42 non-null     float64
 6   2014    42 non-null     float64
 7   2013    41 non-null     float64
 8   2012    40 non-null     float64
dtypes: float64(9)
memory usage: 4.3+ KB

The next step is to get Electricity production capacities for renewables and wastes

siec plant_tec unit geo 2020 2019 2018 2017 2016 2015 ... 1999 1998 1997 1996 1995 1994 1993 1992 1991 1990
0 Solid biofuels Net maximum electrical capacity Megawatt Albania 0.000 0.000 0.000 0.000 0.000 0.000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
1 Solid biofuels Net maximum electrical capacity Megawatt Austria 816.199 813.428 824.253 837.771 916.695 938.621 ... 787.0 747.0 609.0 607.0 544.0 412.0 412.0 400.0 400.0 400.0
2 Solid biofuels Net maximum electrical capacity Megawatt Bosnia and Herzegovina 1.120 1.220 0.250 0.000 0.000 0.000 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
3 Solid biofuels Net maximum electrical capacity Megawatt Belgium 563.500 539.200 526.300 559.200 566.300 591.300 ... 38.0 18.0 11.0 19.0 23.0 11.0 11.0 18.0 26.0 26.0
4 Solid biofuels Net maximum electrical capacity Megawatt Bulgaria 15.064 23.513 33.019 22.973 19.000 34.000 ... 52.0 52.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1070 Municipal waste Net maximum electrical capacity Megawatt Slovakia 12.000 12.000 12.000 12.000 19.000 11.000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
1071 Municipal waste Net maximum electrical capacity Megawatt Türkiye 4.600 4.499 2.499 0.000 0.000 0.000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
1072 Municipal waste Net maximum electrical capacity Megawatt Ukraine 0.000 0.000 0.000 0.000 0.000 0.000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
1073 Municipal waste Net maximum electrical capacity Megawatt United Kingdom NaN 1321.434 1136.727 1090.933 1028.285 929.940 ... 161.0 162.0 115.0 115.0 87.0 87.0 50.0 45.0 31.0 31.0
1074 Municipal waste Net maximum electrical capacity Megawatt Kosovo (under United Nations Security Council ... 0.000 0.000 0.000 0.000 0.000 0.000 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN

1075 rows × 35 columns

siec plant_tec unit geo 2020 2019 2018 2017 2016 2015 ... 1999 1998 1997 1996 1995 1994 1993 1992 1991 1990
0 Solid biofuels Net maximum electrical capacity Megawatt Albania 0.000 0.000 0.000 0.000 0.000 0.000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
1 Solid biofuels Net maximum electrical capacity Megawatt Austria 816.199 813.428 824.253 837.771 916.695 938.621 ... 787.0 747.0 609.0 607.0 544.0 412.0 412.0 400.0 400.0 400.0
2 Solid biofuels Net maximum electrical capacity Megawatt Bosnia and Herzegovina 1.120 1.220 0.250 0.000 0.000 0.000 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
3 Solid biofuels Net maximum electrical capacity Megawatt Belgium 563.500 539.200 526.300 559.200 566.300 591.300 ... 38.0 18.0 11.0 19.0 23.0 11.0 11.0 18.0 26.0 26.0
4 Solid biofuels Net maximum electrical capacity Megawatt Bulgaria 15.064 23.513 33.019 22.973 19.000 34.000 ... 52.0 52.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1070 Municipal waste Net maximum electrical capacity Megawatt Slovakia 12.000 12.000 12.000 12.000 19.000 11.000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
1071 Municipal waste Net maximum electrical capacity Megawatt Türkiye 4.600 4.499 2.499 0.000 0.000 0.000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
1072 Municipal waste Net maximum electrical capacity Megawatt Ukraine 0.000 0.000 0.000 0.000 0.000 0.000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
1073 Municipal waste Net maximum electrical capacity Megawatt United Kingdom NaN 1321.434 1136.727 1090.933 1028.285 929.940 ... 161.0 162.0 115.0 115.0 87.0 87.0 50.0 45.0 31.0 31.0
1074 Municipal waste Net maximum electrical capacity Megawatt Kosovo (under United Nations Security Council ... 0.000 0.000 0.000 0.000 0.000 0.000 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN

1075 rows × 35 columns

(1075, 35)
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 1075 entries, 0 to 1074
Data columns (total 35 columns):
 #   Column     Non-Null Count  Dtype  
---  ------     --------------  -----  
 0   siec       1075 non-null   object 
 1   plant_tec  1075 non-null   object 
 2   unit       1075 non-null   object 
 3   geo        1075 non-null   object 
 4   2020       1050 non-null   float64
 5   2019       1074 non-null   float64
 6   2018       1075 non-null   float64
 7   2017       1075 non-null   float64
 8   2016       1075 non-null   float64
 9   2015       1075 non-null   float64
 10  2014       1075 non-null   float64
 11  2013       1025 non-null   float64
 12  2012       1000 non-null   float64
 13  2011       1000 non-null   float64
 14  2010       1000 non-null   float64
 15  2009       975 non-null    float64
 16  2008       975 non-null    float64
 17  2007       975 non-null    float64
 18  2006       975 non-null    float64
 19  2005       975 non-null    float64
 20  2004       950 non-null    float64
 21  2003       950 non-null    float64
 22  2002       950 non-null    float64
 23  2001       950 non-null    float64
 24  2000       950 non-null    float64
 25  1999       925 non-null    float64
 26  1998       925 non-null    float64
 27  1997       925 non-null    float64
 28  1996       925 non-null    float64
 29  1995       925 non-null    float64
 30  1994       925 non-null    float64
 31  1993       925 non-null    float64
 32  1992       925 non-null    float64
 33  1991       925 non-null    float64
 34  1990       925 non-null    float64
dtypes: float64(31), object(4)
memory usage: 294.1+ KB
['Solid biofuels' 'Pure biogasoline' 'Pure biodiesels'
 'Other liquid biofuels' 'Biogases' 'Hydro' 'Pure hydro power'
 'Run-of-river hydro power' 'Mixed hydro power' 'Pumped hydro power'
 'Geothermal' 'Wind' 'Wind on shore' 'Wind off shore' 'Solar'
 'Solar thermal' 'Solar photovoltaic'
 'Solar photovoltaic (20 kW - 1000 kW)' 'Solar photovoltaic (< 20 kW)'
 'Solar photovoltaic (1+ MW)' 'Solar photovoltaic (Off grid)'
 'Tide, wave, ocean' 'Waste' 'Industrial waste (non-renewable)'
 'Municipal waste']
siec plant_tec unit geo 2020 2019 2018 2017 2016 2015 ... 1999 1998 1997 1996 1995 1994 1993 1992 1991 1990

0 rows × 35 columns